Let AI do the hard part of writing reports! With this spreadsheet you can quickly copy over your student names, attendance, grades and target grades etc. Then provide three short descriptors for each student, could be a single word, could be a sentance. The last cell populates with an instruction you can copy into chat gpt which will return a report for that student. You can then refine that report either by asking chat gpt to modify it or manually yourself.
Hoping to make Excel easy!
Here is a fully functioning Spreadsheet to record test scores for all of your students. You can include multiple classes and even multiple tutors. The spreadsheet also offers in-built analysis of the data, by class, by tutor or even by student.
I have done all the hard bits for you, however, particularly for the analysis section you may want to read the very short guidance attached to understand how it works and how you can use it :-)
This is the second resource in a little series of spreadsheets I have been producing recently.
First one: https://www.tes.com/teaching-resource/resource-12645342
Third one: https://www.tes.com/teaching-resource/resource-12653202
Hoping to make Excel easy!
Here is a fully functioning Register to keep track of the attendance of all of your students. You can include multiple classes and even multiple tutors. The spreadsheet also offers some analysis of the data, by class or by tutor.
Although I have done all the hard bits for you, it will still take a little understanding to get up and running (5mins tops). So I have written a short guide to take you through it.
This is the first in a little series of spreadsheets I hope to produce over the next few months.
Second one: https://www.tes.com/teaching-resource/-12651600
Third one: https://www.tes.com/teaching-resource/resource-12653202
Hoping to make Excel easy!
Here is a spreadsheet that allows you to create your own report templates and then merge them together for your students.
I have done all the hard bits for you, you simply write the templates, then put in the student names and bits of data you wish to include and then pick the template/s you wish to apply to that student and the report will automatically generate.
The spreadsheet is fully adaptable and should work for many different scenarios. I have also written a short guide for anyone who needs it.
This is the third resource in a little series of spreadsheets I have been producing recently.
First one: https://www.tes.com/teaching-resource/resource-12645342
Second one: https://www.tes.com/teaching-resource/resource-12651600
YouTube has loads of great educational, inspirational, interesting and amusing videos. But finding them takes time, lots of time. I have spent the last few months trawling through for some of the very best videos that should draw the attention of your students for a form/tutor time or an assembly or just a break in the lesson. There are various categories: History, Geography, Engineering, English, Biology, Chemistry, Physics, Sport, World affairs, Music, Weird & Wonderful, Funny, Food, Animals and Art. I have picked videos that I hope will either entertain, educate or inspire discussion. This could be the perfect solution for those 5-10 minute time fillers that we all have during the week.
I will be continuing to search for more videos and will post a Volume 2 as soon as it is ready, it may take another few months again however to ensure all the videos are a high enough standard.
Introducing the Teacherβs Markbook - Making Excel easy! This Excel file is all you need to bring your Markbook fully into the 21st Century dazzling colleagues and students alike. Microsoft Excel is a fantastic tool, but hard to learn, yet this is unnecessary because I have done ALL of the hard work for you. This is now the 4th Edition and appears pretty bug free, ty for the feedback :-)
Features: Classwork Markbook, Homework Markbook, Gap Analysis/Traffic Light sheets for Tests and Level Trackers for GCSE 9-1, GCSE A*-U and National Curriculum (3a etc.). The Report Sheet has also been updated giving you suggested attitude/attainment scores for each pupil automatically.
If something isnβt working please tweet me @BGSPayne or email me tpayne@bordengrammar.kent.sch.uk - I will reply.